SUPPORT / SAMPLES & SAS NOTES
Problem Note 55922: "ORA-00942: table or view does not exist" might be generated in SAS® Merchandise Allocation
 |  |  |  |
In SAS Merchandise Allocation, the following exception might be generated in the file:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
The exception is generated because the create script does not grant privileges to a new SAS Merchandise Allocation table called MAXAPP.BATCH_ALLOC_STATUS.
Contact Technical Support for a workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Allocation | 64-bit Enabled AIX | 3.5 | 3.5_M1 | 9.4 TS1M1 | 9.4 TS1M1 |
| Linux for x64 | 3.5 | 3.5_M1 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 R2 | 3.5 | 3.5_M1 | 9.4 TS1M1 | 9.4 TS1M1 | ||